package com.atguigu.entity.excel;


import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ContentFontStyle;
import com.alibaba.excel.annotation.write.style.ContentStyle;
import com.alibaba.excel.annotation.write.style.HeadFontStyle;
import com.alibaba.excel.annotation.write.style.HeadStyle;
import com.alibaba.excel.enums.BooleanEnum;
import com.alibaba.excel.enums.poi.BorderStyleEnum;
import com.alibaba.excel.enums.poi.FillPatternTypeEnum;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import lombok.Data;


//表头字体样式： 字体+颜色+加粗
@HeadFontStyle(fontName = "楷体" ,color = 17 , bold = BooleanEnum.TRUE)
//表头单元格样式：
@HeadStyle(fillBackgroundColor = 14 , fillPatternType = FillPatternTypeEnum.DIAMONDS,
        borderTop = BorderStyleEnum.DOUBLE , topBorderColor =5  )
@Data
public class DistrictInfoExcel {
    /**
     * 区域id
     */
    @ContentFontStyle(fontName = "微软雅黑" , color = 20)
    @ContentStyle(fillBackgroundColor = 33 , fillPatternType = FillPatternTypeEnum.BIG_SPOTS,
            locked = BooleanEnum.TRUE)


    // value = "编号" 表头名称，
    // index = 8 表示该字段对应的是 Excel 表格中的第 9 列（因为索引从 0 开始）
    @ExcelProperty( index = 8 ,value = "编号")
    private Integer id;



    /**
     * 区域名称
     */
    @ExcelProperty( value = "名称")

    private String name;
    /**
     * 所属城市id
     */
    @ExcelProperty( value = "城市编号")

    private Integer cityId;
}
